Adding Columns

You can add columns in a table manually and enter technical and business properties of a column. You can also use user defined fields to enter additional properties of the column. UI labels of user defined fields can be configured in Language Settings.

To add columns in tables manually, follow these steps:

  1. Go to Application Menu > Data Catalog > Metadata Manager > Explore.
  2. In the Data Catalog pane, right-click a table.

    3. The available options appear.

  3. Click Add Column/Field.

    4. The Add New Column page appears.

  4. Enter or select appropriate values in the fields. Refer to the following table for field description.

    5. Field Name

    Sub-Field

    Description

    Technical Properties

    Name

    Specifies the physical name of the column.

    For example, Object_ID.

    Data Domain

    Specifies the data domain values for the column.

    For example, data domain of a Gender column is M and F.

    Precision

    Specifies the precision of the column.

    For example: 5, the number 123.45 has a precision of 5 and a scale of 2.

    DB Default Value

    Specifies the default value of the column in the database.

    For example, True.

    Nullable Flag

    Specifies whether the column allows null values.

    Select the check box if the column allows null values.

    Natural Key Flag

    Specifies whether the column is a natural key.

    Select the check box if the column is a natural key.

    Foreign Key Flag

    Specifies whether the column is a foreign key.

    Select the check box if the column is a foreign key.

    Foreign Key Column Name

    Specifies the actual column name where the column is listed as a PK (in case the current column being an FK).

    For example, ID.

    Minimum Value

    Specifies the minimum value of the column.

    For example, minimum value of ID column can be 424.

    File Starting Position

    Specifies the starting position in the file.

    Attribute Type

    Specifies the attribute type of the new component. It is autopopulated with Column.

    Data Type

    Specifies the physical data type of the column.

    For example, varchar.

    Storage Type

    Specifies the storage type of the column.

    For example, row store/column store in the case of SAP systems.

    Length

    Specifies the physical length of the column.

    For example, if the column datatype is char(5), then its physical length is 5.

    Scale

    Specifies the physical scale of the column.

    For example: The number 123.45 has a precision of 5 and a scale of 2.

    Identity Flag

    Specifies whether the column is used as an identity flag.

    Select the check box if the column is used as an identity flag.

    Percent Null Value

    Specifies the percentage of null values in the column.

    For example, 10%.

    Primary Key Flag

    Specifies whether the column is a primary key.

    Select the check box if the column is used as the primary key.

    Foreign Key Table Name

    Specifies the actual table name where the column is listed as a PK (in case of the current column being an FK).

    ETL Default Value

    Specifies the default ETL value of the column during the load process.

    Maximum Value

    Specifies the maximum value of the column.

    For example, maximum value of ID column can be 1503.

    Business Properties

    Data Steward

    Specifies the data steward responsible for the column.

    For example, Jane Doe.

    Users assigned with the Legacy Data Steward role appear as drop down options. You can assign this role to a user in the Resource Manager.

    To assign data steward, select a data steward from the drop down options.

    Definition

    Specifies the definition of the column.

    For example: The column is a primary key that allows 5 alpha-numeric characters.

    Comments

    Specifies the comments about the column.

    For example: The column provides unique identification of employee in the employee table.

    Sensitive Data Indicator (SDI) Flag

    Specifies whether the column is sensitive.

    Switch Sensitive Data Indicator (SDI) Flag to to mark the column sensitive.

    Sensitive Data Indicator (SDI) Classification

    Specifies the SDI classification of the column.

    For example, PHI.

    This list is enabled when Sensitive Data Indicator (SDI) Flag is switched to . For more information on configuring SDI classifications, refer to the Configuring Sensitive Data Indicator Classifications topic.

    Sensitive Data Indicator (SDI) Description

    Specifies the description of the SDI classification.

    For example: Protected Health Information.

    It is enabled when Sensitive Data Indicator (SDI) Flag is switched to . The field autopopulates based on the SDI classification.

    Class

    Specifies the column class property.

    Select a column class. For more information on configuring column class, refer to the Configuring Table and Column Class topic.

    DQ Score

    Specifies the overall data quality score of the column.

    For example, High (7-8).

    For more information on configuring DQ scores, refer to the Configuring Data Profiling and DQ Scores topic.

    This option is not available when the Enable DQ Sync option is switched on for an environment.

    Logical Name

    Specifies the logical name of the column.

    For example, if the physical name of the table is CUST_ID_NUM, then the logical name of the table is Customer Identification Number.

    Expanded Logical Name

    Specifies the expanded logical name of the column.

    For example, if the physical name of the column is Resource_ID, then the logical name of the .

    You can also configure expanded logical name of columns in bulk at system and environment level.

    JSON Physical Column Name

    Specifies the JSON physical name of the column if the column is in a JSON environment.

    For example, objectID.

    Used in Gap Analysis

    Specifies whether the column is being used in a gap analysis for usage in mappings.

    Select the check box if the column is used in the gap analysis.

    For more information on performing column gap analysis, refer to the Performing Column Gap Analysis topic.

    Alias

    Specifies the alias name of the column.

    For example, Resource_ID.

    Business Key Flag

    Specifies whether the column is a business key.

    Select the check box if the column is a business key.
  5. Click .

    6. The column is added to the table.